﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using CMD_DKT.DAL;

namespace CMD.BAL.MISC
{
    public class SolicitudRol
    {
        public static DataTable InsertNewRol(String unidSolicitud,String  unid_rol,String Id_solicitud_status)
        {
            DataTable dt;
            try
            {
                
                //ejecutar store
                dt = CMD_DKT.DAL.SrvDB.ExecuteQuery("exec SP_CMD_INSERT_ROL @UNID_SOLICITUD="+unidSolicitud+
                    ",@UNID_ROL="+ unid_rol +
                    ",@ID_SOLICITUD_STATUS=" + Id_solicitud_status );
                return dt;
            }
            catch (Exception ex)
            {
                return null;
            }
        }
    }
}
